SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Awesome-Scroll-Back-To-Top-Button-With-Progress-Indicator-Release.zip

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...